<!DOCTYPE html>
<html lang="en">
<head>
<title>How do I download Tests &amp; Quizzes submissions for grading offline?</title>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<meta content="" name="description">
<link href="../css/help.css" media="all" rel="stylesheet" type="text/css" charset="utf-8">
<link href="/library/webjars/fontawesome/4.7.0/css/font-awesome.min.css" media="screen" rel="stylesheet">
<link href="/library/skin/morpheus-default/tool.css" media="screen" rel="stylesheet" type="text/css" charset="utf-8">
<script src="/library/webjars/jquery/1.12.4/jquery.min.js" type="text/javascript" charset="utf-8"></script>
<script src="/library/js/headscripts.js" type="text/javascript" charset="utf-8"></script>
<script type="text/javascript" charset="utf-8">
    includeWebjarLibrary('featherlight');
    $(document).ready(function(){
      $("a.screensteps-image-zoom").featherlight({
        type: { image:true },
        closeOnClick: 'anywhere'
      }); 
    });   
</script>
</head>
<body>
  <div><div>
<div><h1 class="article-title">How do I download Tests &amp; Quizzes submissions for grading offline?</h1></div>
<div>



    <div class="step-instructions screensteps-textblock screensteps-wrapper--introduction screensteps-wrapper">
  <div id="text-content_78918CD7-009A-4C4D-A15E-AEEC9319A98A" class="text-block-content">
    <p>You can download assessment responses for grading offline, including bulk downloading submissions to a <a href="content.hlp?docId=howdoicreateafileuploadquestion">File Upload</a> question so you can easily access them from a single folder on your computer.</p>
<p>For more information on entering assessment grades and comments, see the following articles:</p>
<ul>
<li><a href="content.hlp?docId=howdoigradetestsquizzes">How do I grade Tests &amp; Quizzes?</a></li>
<li><a href="content.hlp?docId=howdoigivethesamescoreeg0toallstudentswithnosubmissionforanassessment">How do I give same score (e.g., 0) to all students with no submission to an assessment?</a></li>
<li><a href="content.hlp?docId=howdoigradeassessmentsubmissionsbystudent">How do I grade Tests &amp; Quizzes submissions by student?</a></li>
<li><a href="content.hlp?docId=howdoigradeassessmentsubmissionsbyquestion">How do I grade Tests &amp; Quizzes submissions by question?</a></li>
</ul>
  </div>
</div>

      <div class="step screensteps-section screensteps-depth-1">
    <h2 class="step-title screensteps-heading">Go to Tests &amp; Quizzes.</h2>
        <div class="image screensteps-image">
      <img src="https://media.screensteps.com/image_assets/assets/006/496/334/original/c794526e-d0dd-4536-bbd1-963fbf596bff.png" alt="Image of the Tests and Quizzes button." height="107" width="204">
  </div>
 
      <div class="step-instructions screensteps-textblock">
  <div id="text-content_22C0069D-7B26-4CAC-8483-8C6B4DDC1A2D" class="text-block-content">
    <p>Select the <strong>Tests &amp; Quizzes</strong> tool from the Tool Menu of your site.</p>
  </div>
</div>
 
  </div>

      <div class="step screensteps-section screensteps-depth-1">
    <h2 class="step-title screensteps-heading">Select the Published-All View.</h2>
        <div class="image screensteps-image">
      <a href="https://media.screensteps.com/image_assets/assets/002/263/415/original/36dae9d4-2a45-4929-9df2-2bf4c7697c66.png" class="screensteps-image-zoom">
        <img src="https://media.screensteps.com/image_assets/assets/002/263/415/medium/36dae9d4-2a45-4929-9df2-2bf4c7697c66.png" alt="Image of the View options in Tests and Quizzes." height="379" width="855">
      </a>
  </div>
 
      <div class="step-instructions screensteps-textblock">
  <div id="text-content_91EDA9C0-5E44-4F85-9528-4BA4EE657621" class="text-block-content">
    <p>Select the <strong>Published-All</strong> option in the View drop-down to view the assessments that have been released to students in your site.</p>
  </div>
</div>
 
  </div>

      <div class="step screensteps-section screensteps-depth-1">
    <h2 class="step-title screensteps-heading">Go to the assessment submissions.</h2>
        <div class="image screensteps-image">
      <a href="https://media.screensteps.com/image_assets/assets/002/263/422/original/12d8a928-4f3b-4717-a352-666d870d7394.png" class="screensteps-image-zoom">
        <img src="https://media.screensteps.com/image_assets/assets/002/263/422/medium/12d8a928-4f3b-4717-a352-666d870d7394.png" alt="Image of the Scores button." height="386" width="855">
      </a>
  </div>
 
      <div class="step-instructions screensteps-textblock">
  <div id="text-content_05F959B9-AECA-4132-A74C-33EDBF7BC8CC" class="text-block-content">
    <p>Select the <strong>Scores</strong> option from the drop-down menu for the assessment you would like to grade.</p>
<p>Alternatively, you may click on the <strong>number of student submissions</strong> in the <em>Submitted</em> column to view the submissions.</p>
  </div>
</div>
 
  </div>

      <div class="step screensteps-section screensteps-depth-1" id="export-scores-and-students-responses-as-an-excel-spreadsheet">
    <h2 class="step-title screensteps-heading">Export scores and students' responses as an Excel spreadsheet.</h2>
      <div class="step-instructions screensteps-textblock">
  <div id="text-content_24F678EC-08FA-40BF-A0D7-27230E6C3344" class="text-block-content">
    <p>You can export an Excel spreadsheet that contains all the students' responses and scores for an assessment, as well as any comments you entered for students on the <em>Total Scores </em>screen.</p>
  </div>
</div>
 
        <div class="step screensteps-section screensteps-depth-2">
    <h3 class="step-title screensteps-heading">Click Export.</h3>
        <div class="image screensteps-image">
      <img src="https://media.screensteps.com/image_assets/assets/002/263/428/original/d6e1c7f1-1c4a-44e1-9f4c-153a2791f4bc.png" alt="Image of the Export button" height="106" width="507">
  </div>
 
  </div>
 
        <div class="step screensteps-section screensteps-depth-2" id="on-the-following-screen-click-export">
    <h3 class="step-title screensteps-heading">On the following screen, click Export.</h3>
        <div class="image screensteps-image">
      <img src="https://media.screensteps.com/image_assets/assets/002/263/420/original/8f3db4fa-2cc4-4cca-97de-5a2f9aecd1fb.png" alt="Image of the export confirmation button." height="161" width="542">
  </div>
 
      <div class="step-instructions screensteps-textblock">
  <div id="text-content_2507C7ED-8899-4701-B3BB-13EA52C80A43" class="text-block-content">
    <p>Click the second <strong>Export</strong> button on the screen to export the file.</p>
<p>Depending on your browser settings, you may be asked to save or open the file. Once downloaded, you can open the file in a spreadsheet program, such as Excel.</p>
  </div>
</div>
 
  </div>
 
        <div class="step screensteps-section screensteps-depth-2" id="view-spreadsheet">
    <h3 class="step-title screensteps-heading">View spreadsheet.</h3>
        <div class="image screensteps-image">
      <img src="https://media.screensteps.com/image_assets/assets/002/263/434/original/244f2f3e-e548-4a5b-961f-3fd30dbd8951.png" alt="Image of the exported spreadsheet." height="119" width="834">
  </div>
 
      <div class="step-instructions screensteps-textblock">
  <div id="text-content_1AB9759A-81A9-4A9E-A449-A32BF2BE3116" class="text-block-content">
    <p>The resulting spreadsheet lists the students' names, user names, number of the assessment submissions (if multiple submissions were allowed), final scores, any<em> comments</em> you entered for students in the <em>Total Scores</em> screen, and the students' responses to each question.</p>
<p><em><strong>Note:</strong> Certain question types, such as File Upload questions and Audio Recording questions, which need to be graded within the Tests &amp; Quizzes screen, will not be able to display answers in the spreadsheet.</em></p>
  </div>
</div>
 
  </div>
 
  </div>

      <div class="step screensteps-section screensteps-depth-1" id="download-all-file-upload-submissions">
    <h2 class="step-title screensteps-heading">Download all File Upload submissions.</h2>
        <div class="image screensteps-image">
      <img src="https://media.screensteps.com/image_assets/assets/002/263/426/original/b1a11e42-588c-4cdb-a003-171c8a3cd135.png" alt="Image of the Questions button." height="101" width="502">
  </div>
 
      <div class="step-instructions screensteps-textblock">
  <div id="text-content_EDE3FEFD-D286-430B-86D2-339755967670" class="text-block-content">
    <p>If your assessment has a <a href="content.hlp?docId=howdoicreateafileuploadquestion">File Upload</a> question, you can download all submissions to it simultaneously (e.g., to add inline comments, or for ease of reading certain types of files from your computer).</p>
<p>Click on the <strong>Questions</strong> link in the assessment menu to access the list of questions.</p>
  </div>
</div>
 
        <div class="step screensteps-section screensteps-depth-2" id="select-the-file-upload-question">
    <h3 class="step-title screensteps-heading">Select the File Upload question.</h3>
        <div class="image screensteps-image">
      <img src="https://media.screensteps.com/image_assets/assets/002/263/432/original/e232a2df-0322-4971-bedd-4a1b47b57e62.png" alt="Image of the list of questions." height="254" width="623">
  </div>
 
      <div class="step-instructions screensteps-textblock">
  <div id="text-content_DC827660-1429-4502-8FB6-7EB7A14F8CB0" class="text-block-content">
    <p>From the list of question numbers, select the File Upload question. Each question is listed as the letter <strong>Q</strong> with the question number (e.g., <strong>Q1</strong>, <strong>Q2</strong>).</p>
  </div>
</div>
 
  </div>
 
        <div class="step screensteps-section screensteps-depth-2" id="click-download-responses">
    <h3 class="step-title screensteps-heading">Click Download Responses.</h3>
        <div class="image screensteps-image">
      <a href="https://media.screensteps.com/image_assets/assets/002/263/430/original/d9952cfb-a07e-4584-81bc-771e91cd5078.png" class="screensteps-image-zoom">
        <img src="https://media.screensteps.com/image_assets/assets/002/263/430/medium/d9952cfb-a07e-4584-81bc-771e91cd5078.png" alt="Image of the download responses button." height="373" width="855">
      </a>
  </div>
 
  </div>
 
        <div class="step screensteps-section screensteps-depth-2" id="save-and-open-the-zip-file">
    <h3 class="step-title screensteps-heading">Save and open the ZIP file.</h3>
        <div class="image screensteps-image">
      <a href="https://media.screensteps.com/image_assets/assets/006/496/337/original/9a828425-c2d8-4883-9b2b-16f57ed7aab8.png" class="screensteps-image-zoom">
        <img src="https://media.screensteps.com/image_assets/assets/006/496/337/medium/9a828425-c2d8-4883-9b2b-16f57ed7aab8.png" alt="Image to save the downloaded responses." height="542" width="855">
      </a>
  </div>
 
      <div class="step-instructions screensteps-textblock">
  <div id="text-content_E4AC2440-6EBE-43FF-9CE0-F6C08E87591E" class="text-block-content">
    <ol>
<li>Based on your internet browser settings, you may be prompted to save the file. Save it to your local disk.</li>
<li>Unzip the resulting zip file. You can see all the students' submissions in one folder. Each submission will be labeled with the student's name, followed by an underscore, the student's user name, another underscore, and the file name.</li>
</ol>
  </div>
</div>
 
  </div>
 
  </div>


</div>
</div></div>
</body>
</html>
